Report GLO AnaCredit

omc0021 - debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument

Card of business rule debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument

Name	debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument
Code	omc0021
Comment	If there is more than one debtor taking part in an instrument, then for each debtor reported in the counterparty-instrument data set, a joint liabilities record must exist.
Rule Type	Constraint

Server expression of the business rule debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument

select "success"
from 'joint liability'
where exists
(select count(*)
from 'debtor-instrument data'
where 'joint liability'.'reporting agent identifier' = 'debtor-instrument data'.'reporting agent identifier'
and 'joint liability'.'observed agent identifier' = 'debtor-instrument data'.'observed agent identifier'
and 'joint liability'.'counterparty role' = "debtor"
and 'joint liability'.'contract identifier' = 'debtor-instrument data'.'contract identifier'
and 'joint liability'.'instrument identifier' = 'debtor-instrument data'.'instrument identifier'
and 'joint liability'.'reporting reference date' = 'debtor-instrument data'.'reporting reference date'
having count(*) > 1 )
and 'joint liability'.'reporting reference date' = current reporting date

List of DNB-specific attributes of the business rule debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument

business rule classification

other model constraint

business rule scope

Checked within the data delivery

business rule status

active business rule

number of dependencies

severity

signalling

List of attached objects of the business rule debtor-instrument data omc0021 joint liability must exist for multiple debtors on instrument

Entity 'debtor-instrument data'

Home